package com.bonc.rms.mapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

public interface WastageInfoUtilMapper {
	// 获取离职员工
	// SELECT job_number FROM talent WHERE leave_date IS NOT NULL
	List<String> getLeaveEmployeeId(@Param("departmentIdlist")List<Integer> departmentIdlist,@Param("size") int size);

	// 获取离职员工最后一次调薪记录
	// SELECT adjust_date FROM salary_record WHERE job_number=? ORDER BY
	// adjust_date DESC LIMIT 0,1 ";
	String getLeaveEmployeeAdjust(@Param("employeeId")String employeeId);
	//获取部门Id
	//SELECT id FROM department WHERE  parent_id=?
	List<Integer> getDepartmentId(@Param("departmentId")Integer departmentId);

}
